prompt PL/SQL Developer Export User Objects for user XIR_TS@172.20.15.34:1521/GJFICC
prompt Created by zipeng.li on 2023��8��22��
set define off
spool /ts.log

prompt
prompt Creating table TREE
prompt ===================
prompt
create table LZ.TREE
(
  child  VARCHAR2(10),
  parent VARCHAR2(10)
)
tablespace LZ_DAT
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 64K
    next 1M
    minextents 1
    maxextents unlimited
  );

prompt
prompt Creating table TSST_AUTOTEST_ITEM
prompt =================================
prompt
create table LZ.TSST_AUTOTEST_ITEM
(
  menu_id     NUMBER(20) not null,
  inf_id      NUMBER(20) not null,
  status      CHAR(1),
  create_by   VARCHAR2(64),
  create_time DATE,
  update_by   VARCHAR2(64),
  update_time DATE,
  remark      VARCHAR2(500)
)
tablespace LZ_DAT
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 64K
    next 1M
    minextents 1
    maxextents unlimited
  );
comment on table LZ.TSST_AUTOTEST_ITEM
  is '����ƽ̨����������';
comment on column LZ.TSST_AUTOTEST_ITEM.menu_id
  is '�˵�����';
comment on column LZ.TSST_AUTOTEST_ITEM.inf_id
  is '�ӿ�����';
comment on column LZ.TSST_AUTOTEST_ITEM.status
  is '״̬';

prompt
prompt Creating table TSST_AUTOTEST_MENU
prompt =================================
prompt
create table LZ.TSST_AUTOTEST_MENU
(
  menu_id        NUMBER(20) not null,
  menu_name      VARCHAR2(50) not null,
  parent_id      NUMBER(20),
  order_num      NUMBER(4),
  menu_type      CHAR(1),
  status         CHAR(1),
  create_by      VARCHAR2(64),
  create_time    DATE,
  update_by      VARCHAR2(64),
  update_time    DATE,
  remark         VARCHAR2(500),
  cycle_number   NUMBER(20),
  run_env        VARCHAR2(64),
  thread_number  NUMBER(20),
  param_source   VARCHAR2(10),
  mcs            VARCHAR2(10),
  record_version VARCHAR2(10)
)
tablespace LZ_DAT
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 64K
    next 1M
    minextents 1
    maxextents unlimited
  );
comment on table LZ.TSST_AUTOTEST_MENU
  is '����ƽ̨���Ա�';
comment on column LZ.TSST_AUTOTEST_MENU.menu_id
  is '�˵�����';
comment on column LZ.TSST_AUTOTEST_MENU.menu_name
  is '�˵�����';
comment on column LZ.TSST_AUTOTEST_MENU.parent_id
  is '���˵�ID';
comment on column LZ.TSST_AUTOTEST_MENU.order_num
  is '��ʾ˳��';
comment on column LZ.TSST_AUTOTEST_MENU.menu_type
  is '�˵�����';
comment on column LZ.TSST_AUTOTEST_MENU.status
  is '״̬';
comment on column LZ.TSST_AUTOTEST_MENU.cycle_number
  is 'ѭ������';
comment on column LZ.TSST_AUTOTEST_MENU.run_env
  is '���л���';
comment on column LZ.TSST_AUTOTEST_MENU.thread_number
  is '�߳���';
comment on column LZ.TSST_AUTOTEST_MENU.param_source
  is '����Դ';
comment on column LZ.TSST_AUTOTEST_MENU.mcs
  is '�Ƿ��ؼ������';
comment on column LZ.TSST_AUTOTEST_MENU.record_version
  is '�Ƿ��¼�汾';

prompt
prompt Creating table TSST_ENV
prompt =======================
prompt
create table LZ.TSST_ENV
(
  env_id      NUMBER(20) not null,
  env_name    VARCHAR2(200),
  address     VARCHAR2(200),
  status      VARCHAR2(100),
  create_by   VARCHAR2(64),
  update_by   VARCHAR2(64),
  remark      VARCHAR2(500),
  is_default  CHAR(1),
  create_time VARCHAR2(21),
  update_time VARCHAR2(21)
)
tablespace LZ_DAT
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 64K
    next 1M
    minextents 1
    maxextents unlimited
  );
comment on column LZ.TSST_ENV.env_id
  is '����ID';
comment on column LZ.TSST_ENV.env_name
  is '��������';
comment on column LZ.TSST_ENV.env_key
  is '����KEy';
comment on column LZ.TSST_ENV.address
  is 'IP��ַ';
comment on column LZ.TSST_ENV.status
  is '״̬';
comment on column LZ.TSST_ENV.remark
  is '��ע';
comment on column LZ.TSST_ENV.account
  is '�˻�';
comment on column LZ.TSST_ENV.password
  is '����';
comment on column LZ.TSST_ENV.is_default
  is 'Ĭ�ϻ���';

prompt
prompt Creating table TSST_INF
prompt =======================
prompt
create table LZ.TSST_INF
(
  inf_id        NUMBER(20),
  inf_code      VARCHAR2(120),
  parent_id     NUMBER(20),
  ancestors     VARCHAR2(120),
  inf_name      VARCHAR2(120),
  leader        VARCHAR2(120),
  inf_url       VARCHAR2(120),
  inf_request   CLOB,
  inf_response  CLOB,
  inf_method    VARCHAR2(120),
  content_type  VARCHAR2(120),
  authorization VARCHAR2(500),
  cookie        VARCHAR2(500),
  no_login      VARCHAR2(64) default 1,
  order_num     NUMBER(16),
  del_flag      CHAR(1),
  status        CHAR(1),
  inf_type      VARCHAR2(64),
  inf_env       VARCHAR2(120),
  param_type    VARCHAR2(120),
  concurrency   NUMBER(20),
  round         NUMBER(20),
  param_source  VARCHAR2(120),
  success       VARCHAR2(64),
  status_code   NUMBER(20),
  calc_type     VARCHAR2(50),
  product_type  VARCHAR2(100),
  option_type   VARCHAR2(100),
  inf_property  VARCHAR2(100),
  time_out      NUMBER(20),
  inf_request1   VARCHAR2(4000),
  inf_request2   VARCHAR2(4000),
  inf_request3   VARCHAR2(4000),
  inf_request4   VARCHAR2(4000),
  inf_request5   VARCHAR2(4000),
  inf_request6   VARCHAR2(4000),
  inf_inner   char(1),
  create_by     VARCHAR2(64),
  create_time   VARCHAR2(64),
  update_by     VARCHAR2(64),
  update_time   VARCHAR2(64)
)
tablespace LZ_DAT
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 64K
    next 1M
    minextents 1
    maxextents unlimited
  );
comment on column LZ.TSST_INF.inf_type
  is 'Ŀ¼C  �ӿ�I';
comment on column LZ.TSST_INF.inf_env
  is '���󻷾�';
comment on column LZ.TSST_INF.param_type
  is '�������� json  xml ';
comment on column LZ.TSST_INF.concurrency
  is '������';
comment on column LZ.TSST_INF.round
  is '�ִ�';
comment on column LZ.TSST_INF.param_source
  is '������Դ log ��־  input �������';
comment on column LZ.TSST_INF.status_code
  is '״̬��';
comment on column LZ.TSST_INF.calc_type
  is '��������';
comment on column LZ.TSST_INF.product_type
  is '��Ʒ����';
comment on column LZ.TSST_INF.option_type
  is '��Ȩ����';
comment on column LZ.TSST_INF.inf_property
  is '�ӿ����� ϵͳ�� ���۲���   ����';
comment on column LZ.TSST_INF.time_out
  is '��ʱʱ��';
  
  create index IDX_TSST_INF_1 on TSST_INF (PARENT_ID) ;
-- Create/Recreate primary, unique and foreign key constraints 
alter table TSST_INF
  add constraint PK_TSST_INF primary key (INF_ID) ;

prompt
prompt Creating table TSST_REPORT
prompt ==========================
prompt
create table LZ.TSST_REPORT
(
  report_id          VARCHAR2(100) not null,
  report_type        VARCHAR2(100),
  calc_date          VARCHAR2(10),
  inf_request        CLOB,
  inf_response       CLOB,
  request_time       VARCHAR2(23),
  response_time      VARCHAR2(23),
  calc_type          VARCHAR2(50),
  product_type       VARCHAR2(100),
  option_type        VARCHAR2(100),
  calc_pricing_param VARCHAR2(50),
  consume_time       VARCHAR2(100),
  max_consume_time   NUMBER(16),
  avg_consume_time   NUMBER(16),
  min_consume_time   NUMBER(16),
  report_name        VARCHAR2(2000),
  report_version     VARCHAR2(64),
  inf_id             VARCHAR2(64),
  inf_env            VARCHAR2(64),
  inf_name           VARCHAR2(64),
  success            VARCHAR2(64),
  round              NUMBER(16),
  concurrency        NUMBER(16),
  count              NUMBER(16),
  fail_count         NUMBER(16),
  success_count      NUMBER(16),
  status             VARCHAR2(64),
  remark             VARCHAR2(255),
  create_by          VARCHAR2(64),
  create_time        VARCHAR2(64),
  update_by          VARCHAR2(64),
  update_time        VARCHAR2(64),
  all_response       CLOB,
  all_consume_time   CLOB,
  all_inf_info       CLOB,
  menu_id            NUMBER(20),
  inf_url            CLOB,
  inf_method         CLOB,
  report_source      VARCHAR2(10),
  mcs                VARCHAR2(10)
)
tablespace LZ_DAT
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 64K
    next 1M
    minextents 1
    maxextents unlimited
  );
comment on column LZ.TSST_REPORT.report_type
  is '�������� S :���� B: ����';
comment on column LZ.TSST_REPORT.calc_date
  is '������ ѹ������';
comment on column LZ.TSST_REPORT.inf_request
  is '���';
comment on column LZ.TSST_REPORT.inf_response
  is '����';
comment on column LZ.TSST_REPORT.request_time
  is '����ʱ��';
comment on column LZ.TSST_REPORT.response_time
  is '��Ӧʱ��';
comment on column LZ.TSST_REPORT.calc_type
  is '��������';
comment on column LZ.TSST_REPORT.product_type
  is '��Ʒ����';
comment on column LZ.TSST_REPORT.option_type
  is '��Ȩ����';
comment on column LZ.TSST_REPORT.calc_pricing_param
  is '���۲���';
comment on column LZ.TSST_REPORT.consume_time
  is '��ʱ';
comment on column LZ.TSST_REPORT.report_name
  is '��������';
comment on column LZ.TSST_REPORT.report_version
  is '�汾';
comment on column LZ.TSST_REPORT.inf_id
  is '���ʱ����Ӧ�Ľӿ�';
comment on column LZ.TSST_REPORT.inf_env
  is '����';
comment on column LZ.TSST_REPORT.inf_name
  is '�ӿ�����';
comment on column LZ.TSST_REPORT.success
  is '�ɹ� ʧ��';
comment on column LZ.TSST_REPORT.round
  is '�ִ�';
comment on column LZ.TSST_REPORT.concurrency
  is '������';
comment on column LZ.TSST_REPORT.count
  is '����';
comment on column LZ.TSST_REPORT.status
  is '���״̬';
comment on column LZ.TSST_REPORT.remark
  is '��ע';
comment on column LZ.TSST_REPORT.create_by
  is '������';
comment on column LZ.TSST_REPORT.create_time
  is '����ʱ��';
comment on column LZ.TSST_REPORT.update_by
  is '������';
comment on column LZ.TSST_REPORT.update_time
  is '����ʱ��';
comment on column LZ.TSST_REPORT.all_response
  is '�ܽ��';
comment on column LZ.TSST_REPORT.all_consume_time
  is 'ÿ���ӿڵĺ�ʱ';
comment on column LZ.TSST_REPORT.all_inf_info
  is '����ӿ���Ϣ';
comment on column LZ.TSST_REPORT.menu_id
  is '��Ӧ�Զ������Բ˵�';
comment on column LZ.TSST_REPORT.inf_url
  is '�ӿ�·��';
comment on column LZ.TSST_REPORT.inf_method
  is '�ӿڷ���';
comment on column LZ.TSST_REPORT.report_source
  is '������Դ';
comment on column LZ.TSST_REPORT.mcs
  is '�Ƿ��ؼ������';

prompt
prompt Creating table TSST_REPORT_ITEM
prompt ===============================
prompt
create table LZ.TSST_REPORT_ITEM
(
  report_id        VARCHAR2(100) not null,
  calc_date        VARCHAR2(10),
  consume_time     VARCHAR2(100),
  max_consume_time NUMBER(16),
  avg_consume_time NUMBER(16),
  min_consume_time NUMBER(16),
  report_name      VARCHAR2(2000),
  inf_env          VARCHAR2(64),
  count            NUMBER(16),
  fail_count       NUMBER(16),
  success_count    NUMBER(16),
  all_consume_time CLOB,
  all_inf_info     CLOB,
  menu_id          NUMBER(20),
  start_time       VARCHAR2(19),
  end_time         VARCHAR2(19),
  create_by        VARCHAR2(64),
  create_time      VARCHAR2(64),
  round            NUMBER(16),
  concurrency      NUMBER(16),
  status           CHAR(1),
  result           CLOB
)
tablespace LZ_DAT
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 64K
    next 1M
    minextents 1
    maxextents unlimited
  );
comment on column LZ.TSST_REPORT_ITEM.report_id
  is '����ID';
comment on column LZ.TSST_REPORT_ITEM.calc_date
  is 'ѹ������';
comment on column LZ.TSST_REPORT_ITEM.consume_time
  is '����ʱ��';
comment on column LZ.TSST_REPORT_ITEM.max_consume_time
  is '����ʱ';
comment on column LZ.TSST_REPORT_ITEM.avg_consume_time
  is 'ƽ����ʱ';
comment on column LZ.TSST_REPORT_ITEM.min_consume_time
  is '��С��ʱ';
comment on column LZ.TSST_REPORT_ITEM.report_name
  is '��������';
comment on column LZ.TSST_REPORT_ITEM.inf_env
  is '���Ի���';
comment on column LZ.TSST_REPORT_ITEM.count
  is '������';
comment on column LZ.TSST_REPORT_ITEM.fail_count
  is 'ʧ������';
comment on column LZ.TSST_REPORT_ITEM.success_count
  is '�ɹ�����';
comment on column LZ.TSST_REPORT_ITEM.all_consume_time
  is '��������ʱ��';
comment on column LZ.TSST_REPORT_ITEM.all_inf_info
  is '���нӿ���Ϣ';
comment on column LZ.TSST_REPORT_ITEM.menu_id
  is '��Ӧ���Ի���';
comment on column LZ.TSST_REPORT_ITEM.start_time
  is '��ʼʱ��';
comment on column LZ.TSST_REPORT_ITEM.end_time
  is '����ʱ��';
comment on column LZ.TSST_REPORT_ITEM.create_by
  is '������';
comment on column LZ.TSST_REPORT_ITEM.create_time
  is '����ʱ��';
comment on column LZ.TSST_REPORT_ITEM.round
  is '�ִ�';
comment on column LZ.TSST_REPORT_ITEM.concurrency
  is '������';
comment on column LZ.TSST_REPORT_ITEM.status
  is '���״̬';
comment on column LZ.TSST_REPORT_ITEM.result
  is '�ӿڽ��';

prompt
prompt Creating table TSYS_CALC_LOG
prompt ============================
prompt
create table LZ.TSYS_CALC_LOG
(
  id                NUMBER not null,
  calc_date         VARCHAR2(10),
  up_request        CLOB,
  up_response       CLOB,
  up_request_time   VARCHAR2(12),
  up_response_time  VARCHAR2(12),
  calc_type         VARCHAR2(50),
  status            CHAR(1),
  up_user_id        VARCHAR2(100),
  product_type      VARCHAR2(50),
  calc_server       VARCHAR2(50),
  sys_id            VARCHAR2(100),
  option_type       VARCHAR2(50),
  consume_time      NUMBER,
  instrument        VARCHAR2(500),
  remark            VARCHAR2(255),
  draft_name        VARCHAR2(255),
  value_date        VARCHAR2(10),
  p_form_pricing    CLOB,
  p_form_instrument CLOB,
  p_form_result     CLOB,
  log_type          VARCHAR2(255),
  sys_ip            VARCHAR2(100)
)
tablespace LZ_DAT
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 64K
    next 1M
    minextents 1
    maxextents unlimited
  );
comment on table LZ.TSYS_CALC_LOG
  is '������־��';
comment on column LZ.TSYS_CALC_LOG.id
  is '����';
comment on column LZ.TSYS_CALC_LOG.calc_date
  is '��������ƽ̨���ؽ��ʱ��';
comment on column LZ.TSYS_CALC_LOG.up_request
  is 'ҵ��ϵͳ�������';
comment on column LZ.TSYS_CALC_LOG.up_response
  is '��������ƽ̨���ؼ�����';
comment on column LZ.TSYS_CALC_LOG.up_request_time
  is 'ҵ��ϵͳ����ʱ��';
comment on column LZ.TSYS_CALC_LOG.up_response_time
  is '��������ƽ̨���ؽ��ʱ��';
comment on column LZ.TSYS_CALC_LOG.calc_type
  is '��������';
comment on column LZ.TSYS_CALC_LOG.status
  is '״̬';
comment on column LZ.TSYS_CALC_LOG.up_user_id
  is '������Ա';
comment on column LZ.TSYS_CALC_LOG.product_type
  is '��Ʒ����';
comment on column LZ.TSYS_CALC_LOG.calc_server
  is '��������ip+port';
comment on column LZ.TSYS_CALC_LOG.sys_id
  is '����������ip����ϵͳ����';
comment on column LZ.TSYS_CALC_LOG.option_type
  is '��Ȩ����';
comment on column LZ.TSYS_CALC_LOG.consume_time
  is '��ʱ';
comment on column LZ.TSYS_CALC_LOG.log_type
  is '1: �ݸ� 0���߿գ���־';
comment on column LZ.TSYS_CALC_LOG.sys_ip
  is '����������ip';

prompt
prompt Creating table TSYS_CONFIG
prompt ==========================
prompt
create table LZ.TSYS_CONFIG
(
  config_id    NUMBER(20) not null,
  config_name  VARCHAR2(200),
  config_key   VARCHAR2(200),
  config_value VARCHAR2(200),
  config_type  VARCHAR2(100),
  create_by    VARCHAR2(64),
  create_time  DATE,
  update_by    VARCHAR2(64),
  update_time  DATE,
  remark       VARCHAR2(500)
)
tablespace LZ_DAT
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 64K
    next 1M
    minextents 1
    maxextents unlimited
  );
comment on table LZ.TSYS_CONFIG
  is '�������ñ�';
comment on column LZ.TSYS_CONFIG.config_id
  is '��������seq_sys_config.nextval';
comment on column LZ.TSYS_CONFIG.config_name
  is '��������';
comment on column LZ.TSYS_CONFIG.config_key
  is '��������';
comment on column LZ.TSYS_CONFIG.config_value
  is '������ֵ';
comment on column LZ.TSYS_CONFIG.config_type
  is '��־log ���monitor ѹ��xts ϵͳsys  ����xtp  ����pricing';
comment on column LZ.TSYS_CONFIG.create_by
  is '������';
comment on column LZ.TSYS_CONFIG.create_time
  is '����ʱ��';
comment on column LZ.TSYS_CONFIG.update_by
  is '������';
comment on column LZ.TSYS_CONFIG.update_time
  is '����ʱ��';
comment on column LZ.TSYS_CONFIG.remark
  is '��ע';
alter table LZ.TSYS_CONFIG
  add constraint PK_SYS_CONFIG primary key (CONFIG_ID)
  using index 
  tablespace LZ_DAT
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    next 1M
    minextents 1
    maxextents unlimited
  );

prompt
prompt Creating table TSYS_DEPT
prompt ========================
prompt
create table LZ.TSYS_DEPT
(
  dept_id     NUMBER(20) not null,
  parent_id   NUMBER(20),
  ancestors   VARCHAR2(50),
  dept_name   VARCHAR2(30),
  order_num   NUMBER(4),
  leader      VARCHAR2(20),
  phone       VARCHAR2(11),
  email       VARCHAR2(50),
  status      CHAR(1),
  del_flag    CHAR(1) default '0',
  create_by   VARCHAR2(64),
  create_time DATE,
  update_by   VARCHAR2(64),
  update_time DATE,
  dept_code   VARCHAR2(30),
  menu_env    VARCHAR2(30)
)
tablespace LZ_DAT
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 64K
    next 1M
    minextents 1
    maxextents unlimited
  );
comment on table LZ.TSYS_DEPT
  is '������Ϣ��';
comment on column LZ.TSYS_DEPT.dept_id
  is '��������seq_sys_dept.nextval';
comment on column LZ.TSYS_DEPT.parent_id
  is '������id';
comment on column LZ.TSYS_DEPT.ancestors
  is '�漶�б�';
comment on column LZ.TSYS_DEPT.dept_name
  is '��������';
comment on column LZ.TSYS_DEPT.order_num
  is '��ʾ˳��';
comment on column LZ.TSYS_DEPT.leader
  is '������';
comment on column LZ.TSYS_DEPT.phone
  is '��ϵ�绰';
comment on column LZ.TSYS_DEPT.email
  is '����';
comment on column LZ.TSYS_DEPT.status
  is '����״̬��0���� 1ͣ�ã�';
comment on column LZ.TSYS_DEPT.del_flag
  is 'ɾ����־��0������� 2����ɾ����';
comment on column LZ.TSYS_DEPT.create_by
  is '������';
comment on column LZ.TSYS_DEPT.create_time
  is '����ʱ��';
comment on column LZ.TSYS_DEPT.update_by
  is '������';
comment on column LZ.TSYS_DEPT.update_time
  is '����ʱ��';
comment on column LZ.TSYS_DEPT.menu_env
  is '�˵�����';
alter table LZ.TSYS_DEPT
  add constraint PK_SYS_DEPT primary key (DEPT_ID)
  using index 
  tablespace LZ_DAT
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    next 1M
    minextents 1
    maxextents unlimited
  );

prompt
prompt Creating table TSYS_DEPT_PERM
prompt =============================
prompt
create table LZ.TSYS_DEPT_PERM
(
  dept_id     NUMBER(20) not null,
  cfg_id      VARCHAR2(1000),
  group_id    VARCHAR2(1000),
  acc_id      VARCHAR2(1000),
  irc_code    VARCHAR2(1000),
  div_code    VARCHAR2(1000),
  vls_code    VARCHAR2(1000),
  create_by   VARCHAR2(64),
  create_time DATE,
  update_by   VARCHAR2(64),
  update_time DATE
)
tablespace LZ_DAT
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 64K
    next 1M
    minextents 1
    maxextents unlimited
  );
comment on table LZ.TSYS_DEPT_PERM
  is '����Ȩ�ޱ���Ų��ŵ��ܹ����е�Ȩ�ޣ��󶨶���˻�';
comment on column LZ.TSYS_DEPT_PERM.dept_id
  is '����ID';
comment on column LZ.TSYS_DEPT_PERM.cfg_id
  is '���ò���ID';
comment on column LZ.TSYS_DEPT_PERM.group_id
  is '��ID';
comment on column LZ.TSYS_DEPT_PERM.acc_id
  is '�����˻�ID';
comment on column LZ.TSYS_DEPT_PERM.irc_code
  is '�������ߴ���';
comment on column LZ.TSYS_DEPT_PERM.div_code
  is '�������ߴ���';
comment on column LZ.TSYS_DEPT_PERM.vls_code
  is '�������������';
alter table LZ.TSYS_DEPT_PERM
  add primary key (DEPT_ID)
  using index 
  tablespace LZ_DAT
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    next 1M
    minextents 1
    maxextents unlimited
  );

prompt
prompt Creating table TSYS_DICT_DATA
prompt =============================
prompt
create table LZ.TSYS_DICT_DATA
(
  dict_code   NUMBER(20) not null,
  dict_sort   NUMBER(4),
  dict_label  VARCHAR2(1000),
  dict_value  VARCHAR2(1000),
  dict_type   VARCHAR2(1000),
  css_class   VARCHAR2(100),
  list_class  VARCHAR2(100),
  is_default  CHAR(1),
  status      CHAR(1),
  create_by   VARCHAR2(64),
  create_time DATE,
  update_by   VARCHAR2(64),
  update_time DATE,
  remark      VARCHAR2(500)
)
tablespace LZ_DAT
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 64K
    next 1M
    minextents 1
    maxextents unlimited
  );
comment on table LZ.TSYS_DICT_DATA
  is '�ֵ����ݱ�';
comment on column LZ.TSYS_DICT_DATA.dict_code
  is '�ֵ�����';
comment on column LZ.TSYS_DICT_DATA.dict_sort
  is '�ֵ�����';
comment on column LZ.TSYS_DICT_DATA.dict_label
  is '�ֵ��ǩ';
comment on column LZ.TSYS_DICT_DATA.dict_value
  is '�ֵ��ֵ';
comment on column LZ.TSYS_DICT_DATA.dict_type
  is '�ֵ�����';
comment on column LZ.TSYS_DICT_DATA.css_class
  is '��ʽ���ԣ�������ʽ��չ��';
comment on column LZ.TSYS_DICT_DATA.list_class
  is '��������ʽ';
comment on column LZ.TSYS_DICT_DATA.is_default
  is '�Ƿ�Ĭ�ϣ�Y�� N��';
comment on column LZ.TSYS_DICT_DATA.status
  is '״̬��0���� 1ͣ�ã�';
comment on column LZ.TSYS_DICT_DATA.create_by
  is '������';
comment on column LZ.TSYS_DICT_DATA.create_time
  is '����ʱ��';
comment on column LZ.TSYS_DICT_DATA.update_by
  is '������';
comment on column LZ.TSYS_DICT_DATA.update_time
  is '����ʱ��';
comment on column LZ.TSYS_DICT_DATA.remark
  is '��ע';
alter table LZ.TSYS_DICT_DATA
  add constraint PK_DICT_CODE primary key (DICT_CODE)
  using index 
  tablespace LZ_DAT
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    next 1M
    minextents 1
    maxextents unlimited
  );

prompt
prompt Creating table TSYS_DICT_TYPE
prompt =============================
prompt
create table LZ.TSYS_DICT_TYPE
(
  dict_id     NUMBER(20) not null,
  dict_name   VARCHAR2(100),
  dict_type   VARCHAR2(100),
  status      CHAR(1),
  create_by   VARCHAR2(64),
  create_time DATE,
  update_by   VARCHAR2(64),
  update_time DATE,
  remark      VARCHAR2(500)
)
tablespace LZ_DAT
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 64K
    next 1M
    minextents 1
    maxextents unlimited
  );
comment on table LZ.TSYS_DICT_TYPE
  is '�ֵ����ͱ�';
comment on column LZ.TSYS_DICT_TYPE.dict_id
  is '�ֵ�����';
comment on column LZ.TSYS_DICT_TYPE.dict_name
  is '�ֵ�����';
comment on column LZ.TSYS_DICT_TYPE.dict_type
  is '�ֵ�����';
comment on column LZ.TSYS_DICT_TYPE.status
  is '״̬��0���� 1ͣ�ã�';
comment on column LZ.TSYS_DICT_TYPE.create_by
  is '������';
comment on column LZ.TSYS_DICT_TYPE.create_time
  is '����ʱ��';
comment on column LZ.TSYS_DICT_TYPE.update_by
  is '������';
comment on column LZ.TSYS_DICT_TYPE.update_time
  is '����ʱ��';
comment on column LZ.TSYS_DICT_TYPE.remark
  is '��ע';
alter table LZ.TSYS_DICT_TYPE
  add constraint PK_TSYS_DICT_TYPE primary key (DICT_ID)
  using index 
  tablespace LZ_DAT
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    next 1M
    minextents 1
    maxextents unlimited
  );

prompt
prompt Creating table TSYS_MENU
prompt ========================
prompt
create table LZ.TSYS_MENU
(
  menu_id     NUMBER(20) not null,
  menu_name   VARCHAR2(50) not null,
  parent_id   NUMBER(20),
  order_num   NUMBER(4),
  path        VARCHAR2(200),
  component   VARCHAR2(255),
  query       VARCHAR2(255),
  is_frame    NUMBER(1),
  is_cache    NUMBER(1),
  menu_type   CHAR(1),
  visible     CHAR(1),
  status      CHAR(1),
  perms       VARCHAR2(100),
  icon        VARCHAR2(100),
  create_by   VARCHAR2(64),
  create_time DATE,
  update_by   VARCHAR2(64),
  update_time DATE,
  remark      VARCHAR2(500),
  menu_env    VARCHAR2(500) not null
)
tablespace LZ_DAT
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 64K
    next 1M
    minextents 1
    maxextents unlimited
  );
comment on table LZ.TSYS_MENU
  is '�˵�Ȩ�ޱ�';
comment on column LZ.TSYS_MENU.menu_id
  is '�˵�����seq_sys_post.nextval';
comment on column LZ.TSYS_MENU.menu_name
  is '�˵�����';
comment on column LZ.TSYS_MENU.parent_id
  is '���˵�ID';
comment on column LZ.TSYS_MENU.order_num
  is '��ʾ˳��';
comment on column LZ.TSYS_MENU.path
  is '�����ַ';
comment on column LZ.TSYS_MENU.component
  is '·�ɵ�ַ';
comment on column LZ.TSYS_MENU.query
  is '·�ɲ���';
comment on column LZ.TSYS_MENU.is_frame
  is '�Ƿ�Ϊ������0�� 1��';
comment on column LZ.TSYS_MENU.is_cache
  is '�Ƿ񻺴棨0���� 1�����棩';
comment on column LZ.TSYS_MENU.menu_type
  is '�˵����ͣ�MĿ¼ C�˵� F��ť��';
comment on column LZ.TSYS_MENU.visible
  is '�˵�״̬��0��ʾ 1���أ�';
comment on column LZ.TSYS_MENU.status
  is '�˵�״̬��0���� 1ͣ�ã�';
comment on column LZ.TSYS_MENU.perms
  is 'Ȩ�ޱ�ʶ';
comment on column LZ.TSYS_MENU.icon
  is '�˵�ͼ��';
comment on column LZ.TSYS_MENU.create_by
  is '������';
comment on column LZ.TSYS_MENU.create_time
  is '����ʱ��';
comment on column LZ.TSYS_MENU.update_by
  is '������';
comment on column LZ.TSYS_MENU.update_time
  is '����ʱ��';
comment on column LZ.TSYS_MENU.remark
  is '��ע';
comment on column LZ.TSYS_MENU.menu_env
  is '��Դ����ƽ̨����ԴEQ��������������ԴEQ���Ի�������Դ����ƽ̨���Ի���';
alter table LZ.TSYS_MENU
  add constraint PK_TSYS_MENU primary key (MENU_ID, MENU_ENV)
  using index 
  tablespace LZ_DAT
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    next 1M
    minextents 1
    maxextents unlimited
  );

prompt
prompt Creating table TSYS_POST
prompt ========================
prompt
create table LZ.TSYS_POST
(
  post_id     NUMBER(20) not null,
  post_code   VARCHAR2(64) not null,
  post_name   VARCHAR2(50) not null,
  post_sort   NUMBER(4) not null,
  status      CHAR(1) not null,
  create_by   VARCHAR2(64),
  create_time DATE,
  update_by   VARCHAR2(64),
  update_time DATE,
  remark      VARCHAR2(500),
  menu_env    VARCHAR2(500)
)
tablespace LZ_DAT
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 64K
    next 1M
    minextents 1
    maxextents unlimited
  );
comment on table LZ.TSYS_POST
  is '��λ��Ϣ��';
comment on column LZ.TSYS_POST.post_id
  is '��λ����seq_sys_post.nextval';
comment on column LZ.TSYS_POST.post_code
  is '��λ����';
comment on column LZ.TSYS_POST.post_name
  is '��λ����';
comment on column LZ.TSYS_POST.post_sort
  is '��ʾ˳��';
comment on column LZ.TSYS_POST.status
  is '״̬��0���� 1ͣ�ã�';
comment on column LZ.TSYS_POST.create_by
  is '������';
comment on column LZ.TSYS_POST.create_time
  is '����ʱ��';
comment on column LZ.TSYS_POST.update_by
  is '������';
comment on column LZ.TSYS_POST.update_time
  is '����ʱ��';
comment on column LZ.TSYS_POST.remark
  is '��ע';
comment on column LZ.TSYS_POST.menu_env
  is '�˵�����';
alter table LZ.TSYS_POST
  add constraint PK_SYS_POST primary key (POST_ID)
  using index 
  tablespace LZ_DAT
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    next 1M
    minextents 1
    maxextents unlimited
  );

prompt
prompt Creating table TSYS_ROLE
prompt ========================
prompt
create table LZ.TSYS_ROLE
(
  role_id             NUMBER(20) not null,
  role_name           VARCHAR2(30) not null,
  role_key            VARCHAR2(100) not null,
  role_sort           NUMBER(4) not null,
  data_scope          CHAR(1),
  menu_check_strictly NUMBER(1),
  dept_check_strictly NUMBER(1),
  status              CHAR(1) not null,
  del_flag            CHAR(1),
  create_by           VARCHAR2(64),
  create_time         DATE,
  update_by           VARCHAR2(64),
  update_time         DATE,
  remark              VARCHAR2(500),
  menu_env            VARCHAR2(500)
)
tablespace LZ_DAT
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 64K
    next 1M
    minextents 1
    maxextents unlimited
  );
comment on table LZ.TSYS_ROLE
  is '��ɫ��Ϣ��';
comment on column LZ.TSYS_ROLE.role_id
  is '��ɫ����';
comment on column LZ.TSYS_ROLE.role_name
  is '��ɫ����';
comment on column LZ.TSYS_ROLE.role_key
  is '��ɫȨ���ַ���';
comment on column LZ.TSYS_ROLE.role_sort
  is '��ʾ˳��';
comment on column LZ.TSYS_ROLE.data_scope
  is '���ݷ�Χ��1��ȫ������Ȩ�� 2���Զ�����Ȩ�ޣ�';
comment on column LZ.TSYS_ROLE.menu_check_strictly
  is '�˵���ѡ�����Ƿ������ʾ';
comment on column LZ.TSYS_ROLE.dept_check_strictly
  is '������ѡ�����Ƿ������ʾ';
comment on column LZ.TSYS_ROLE.status
  is '��ɫ״̬��0���� 1ͣ�ã�';
comment on column LZ.TSYS_ROLE.del_flag
  is 'ɾ����־��0������� 2����ɾ����';
comment on column LZ.TSYS_ROLE.create_by
  is '������';
comment on column LZ.TSYS_ROLE.create_time
  is '����ʱ��';
comment on column LZ.TSYS_ROLE.update_by
  is '������';
comment on column LZ.TSYS_ROLE.update_time
  is '����ʱ��';
comment on column LZ.TSYS_ROLE.remark
  is '��ע';
comment on column LZ.TSYS_ROLE.menu_env
  is '����';
alter table LZ.TSYS_ROLE
  add constraint PK_TSYS_ROLE primary key (ROLE_ID)
  using index 
  tablespace LZ_DAT
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    next 1M
    minextents 1
    maxextents unlimited
  );

prompt
prompt Creating table TSYS_ROLE_MENU
prompt =============================
prompt
create table LZ.TSYS_ROLE_MENU
(
  role_id  NUMBER(20) not null,
  menu_id  NUMBER(20) not null,
  menu_env VARCHAR2(120)
)
tablespace LZ_DAT
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 64K
    next 1M
    minextents 1
    maxextents unlimited
  );
comment on table LZ.TSYS_ROLE_MENU
  is '��ɫ�Ͳ˵�������';
comment on column LZ.TSYS_ROLE_MENU.role_id
  is '��ɫID';
comment on column LZ.TSYS_ROLE_MENU.menu_id
  is '�˵�ID';
comment on column LZ.TSYS_ROLE_MENU.menu_env
  is '�˵�����';

prompt
prompt Creating table TSYS_SHORTCUT_MENU
prompt =================================
prompt
create table LZ.TSYS_SHORTCUT_MENU
(
  menu_id   NUMBER(20),
  menu_user VARCHAR2(50),
  order_num NUMBER(4)
)
tablespace LZ_DAT
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 64K
    next 1M
    minextents 1
    maxextents unlimited
  );
comment on table LZ.TSYS_SHORTCUT_MENU
  is '�˵���ҳ��ݷ�ʽ';
comment on column LZ.TSYS_SHORTCUT_MENU.menu_id
  is 'ID';
comment on column LZ.TSYS_SHORTCUT_MENU.menu_user
  is '�˵�������';
comment on column LZ.TSYS_SHORTCUT_MENU.order_num
  is '���';

prompt
prompt Creating table TSYS_USER
prompt ========================
prompt
create table LZ.TSYS_USER
(
  user_id     NUMBER(20) not null,
  dept_id     NUMBER(20),
  user_name   VARCHAR2(30) not null,
  nick_name   VARCHAR2(30),
  user_type   VARCHAR2(2),
  email       VARCHAR2(50),
  phonenumber VARCHAR2(11),
  sex         CHAR(1),
  avatar      VARCHAR2(100),
  password    VARCHAR2(100),
  status      CHAR(1),
  del_flag    CHAR(1),
  login_ip    VARCHAR2(128),
  login_date  DATE,
  create_by   VARCHAR2(64),
  create_time DATE,
  update_by   VARCHAR2(64),
  update_time DATE,
  remark      VARCHAR2(500),
  uuid        VARCHAR2(128),
  mng_flag    CHAR(1) default '0' not null,
  pric_group  VARCHAR2(255) default (''),
  menu_env    VARCHAR2(255)
)
tablespace LZ_DAT
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 64K
    next 1M
    minextents 1
    maxextents unlimited
  );
comment on table LZ.TSYS_USER
  is '�û���Ϣ��';
comment on column LZ.TSYS_USER.user_id
  is '�û�����seq_sys_user.nextval';
comment on column LZ.TSYS_USER.dept_id
  is '����ID';
comment on column LZ.TSYS_USER.user_name
  is '�û��˺�';
comment on column LZ.TSYS_USER.nick_name
  is '�û��ǳ�';
comment on column LZ.TSYS_USER.user_type
  is '�û����ͣ�00ϵͳ�û� 01ע���û���';
comment on column LZ.TSYS_USER.email
  is '�û�����';
comment on column LZ.TSYS_USER.phonenumber
  is '�ֻ�����';
comment on column LZ.TSYS_USER.sex
  is '�û��Ա�0�� 1Ů 2δ֪��';
comment on column LZ.TSYS_USER.avatar
  is 'ͷ��·��';
comment on column LZ.TSYS_USER.password
  is '����';
comment on column LZ.TSYS_USER.status
  is '�ʺ�״̬��0���� 1ͣ�ã�';
comment on column LZ.TSYS_USER.del_flag
  is 'ɾ����־��0������� 2����ɾ����';
comment on column LZ.TSYS_USER.login_ip
  is '����¼IP';
comment on column LZ.TSYS_USER.login_date
  is '����¼ʱ��';
comment on column LZ.TSYS_USER.create_by
  is '������';
comment on column LZ.TSYS_USER.create_time
  is '����ʱ��';
comment on column LZ.TSYS_USER.update_by
  is '������';
comment on column LZ.TSYS_USER.update_time
  is '����ʱ��';
comment on column LZ.TSYS_USER.remark
  is '��ע';
comment on column LZ.TSYS_USER.menu_env
  is '����';
create index LZ.TSYS_USER_UUID on LZ.TSYS_USER (UUID)
  tablespace LZ_DAT
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    next 1M
    minextents 1
    maxextents unlimited
  );
alter table LZ.TSYS_USER
  add constraint PK_TSYS_USER primary key (USER_ID)
  using index 
  tablespace LZ_DAT
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    next 1M
    minextents 1
    maxextents unlimited
  );

prompt
prompt Creating table TSYS_USER_DEPT
prompt =============================
prompt
create table LZ.TSYS_USER_DEPT
(
  dept_id NUMBER(20) not null,
  user_id NUMBER(20) not null
)
tablespace LZ_DAT
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 64K
    next 1M
    minextents 1
    maxextents unlimited
  );
comment on table LZ.TSYS_USER_DEPT
  is '�û�����Ȩ�ޱ�';
comment on column LZ.TSYS_USER_DEPT.dept_id
  is '����ID';
comment on column LZ.TSYS_USER_DEPT.user_id
  is '����ID';
create index LZ.IDX_TSYS_USER_DEPT_DEPT_ID on LZ.TSYS_USER_DEPT (DEPT_ID)
  tablespace LZ_DAT
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    next 1M
    minextents 1
    maxextents unlimited
  );

prompt
prompt Creating table TSYS_USER_PERM
prompt =============================
prompt
create table LZ.TSYS_USER_PERM
(
  user_id     NUMBER(20) not null,
  cfg_id      VARCHAR2(1000),
  cfg_flag    VARCHAR2(1),
  group_id    VARCHAR2(1000),
  group_flag  VARCHAR2(1),
  acc_id      VARCHAR2(1000),
  acc_flag    VARCHAR2(1),
  irc_code    VARCHAR2(1000),
  irc_flag    VARCHAR2(1),
  div_code    VARCHAR2(1000),
  div_flag    VARCHAR2(1),
  vls_code    VARCHAR2(1000),
  vls_flag    VARCHAR2(1),
  create_by   VARCHAR2(64),
  create_time DATE,
  update_by   VARCHAR2(64),
  update_time DATE
)
tablespace LZ_DAT
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 64K
    next 1M
    minextents 1
    maxextents unlimited
  );
comment on table LZ.TSYS_USER_PERM
  is '�û�Ȩ�ޱ�����û��������ò����Լ��˻���Ȩ��';
comment on column LZ.TSYS_USER_PERM.user_id
  is '�û�ID';
comment on column LZ.TSYS_USER_PERM.cfg_id
  is '����ID';
comment on column LZ.TSYS_USER_PERM.cfg_flag
  is '���ñ�ʶ';
comment on column LZ.TSYS_USER_PERM.group_id
  is '��ID';
comment on column LZ.TSYS_USER_PERM.group_flag
  is '���ʶ';
comment on column LZ.TSYS_USER_PERM.acc_id
  is '�˻�ID';
comment on column LZ.TSYS_USER_PERM.acc_flag
  is '�˻���ʶ';
comment on column LZ.TSYS_USER_PERM.irc_code
  is '�������ߴ���';
comment on column LZ.TSYS_USER_PERM.irc_flag
  is '�������߱�ʶ';
comment on column LZ.TSYS_USER_PERM.div_code
  is '�������ߴ���';
comment on column LZ.TSYS_USER_PERM.div_flag
  is '�������߱�ʶ';
comment on column LZ.TSYS_USER_PERM.vls_code
  is '�������������';
comment on column LZ.TSYS_USER_PERM.vls_flag
  is '�����������ʶ';
alter table LZ.TSYS_USER_PERM
  add primary key (USER_ID)
  using index 
  tablespace LZ_DAT
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    next 1M
    minextents 1
    maxextents unlimited
  );

prompt
prompt Creating table TSYS_USER_POST
prompt =============================
prompt
create table LZ.TSYS_USER_POST
(
  user_id NUMBER(20) not null,
  post_id NUMBER(20) not null
)
tablespace LZ_DAT
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 64K
    next 1M
    minextents 1
    maxextents unlimited
  );
comment on table LZ.TSYS_USER_POST
  is '�û����ű�';
comment on column LZ.TSYS_USER_POST.user_id
  is '�û�ID';
comment on column LZ.TSYS_USER_POST.post_id
  is '����ID';

prompt
prompt Creating table TSYS_USER_ROLE
prompt =============================
prompt
create table LZ.TSYS_USER_ROLE
(
  user_id NUMBER(20) not null,
  role_id NUMBER(20) not null
)
tablespace LZ_DAT
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 64K
    next 1M
    minextents 1
    maxextents unlimited
  );
comment on table LZ.TSYS_USER_ROLE
  is '�û��ͽ�ɫ������';
comment on column LZ.TSYS_USER_ROLE.user_id
  is '�û�ID';
comment on column LZ.TSYS_USER_ROLE.role_id
  is '��ɫID';
alter table LZ.TSYS_USER_ROLE
  add constraint PK_SYS_USER_ROLE primary key (USER_ID, ROLE_ID)
  using index 
  tablespace LZ_DAT
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    next 1M
    minextents 1
    maxextents unlimited
  );

prompt
prompt Creating sequence S_TSYS_MENU
prompt =============================
prompt
create sequence LZ.S_TSYS_MENU
minvalue 1
maxvalue 9999999999
start with 201
increment by 1
cache 20;

prompt
prompt Creating sequence S_TSYS_ROLE
prompt =============================
prompt
create sequence LZ.S_TSYS_ROLE
minvalue 0
maxvalue 9999999999
start with 141
increment by 1
cache 20;


prompt Done
spool off
set define on
